package ca.ualberta.cs.PrivacyManagement;

import java.sql.SQLException;
import java.sql.Statement;

import ca.ualberta.cs.CLRDB.EntityRelManagement;

public class Settings extends EntityRelManagement{

	@Override
	public void initialize(Statement statement) throws SQLException {
		
		//person settings
		statement.executeUpdate("ALTER TABLE PERSON "
                + "ADD COLUMN " + "SHOWNAME CHAR(1) WITH DEFAULT 'n' " 
                + "ADD COLUMN " + "SHOWUSERNAME CHAR(1) WITH DEFAULT 'y' " 
                + "ADD COLUMN " + "SHOWAFFILIATION CHAR(1) WITH DEFAULT 'n' "
                + "ADD COLUMN " + "SHOWJOINDATE CHAR(1) WITH DEFAULT 'n' " 
                + "ADD COLUMN " + "SHOWDESCRIPTION CHAR(1) WITH DEFAULT 'n' "
                + "ADD COLUMN " + "SHOWFRIENDLIST CHAR(1) WITH DEFAULT 'n' " 
                + "ADD COLUMN " + "SHOWPAPER CHAR(1) WITH DEFAULT 'n' "
                + "ADD COLUMN " + "SHOWEMAIL CHAR(1) WITH DEFAULT 'n' "
                + "ADD COLUMN " + "SHOWPUBLICATION CHAR(1) WITH DEFAULT 'y' "
                + "ADD COLUMN " + "LOGINTIMES INT DEFAULT 0 "
                + "ADD COLUMN " + "LASTLOGIN DATE");
		
	}
	
}
